Linux Shell sqlplus输出信息格式化
#!/bin/sh
sqlplus dsg/Zfmjti1_AT << EOF
set pagesize 0
set linesize 400
col table_name for a40
set feedback off;
set heading off;
set termout off;
set trimspool on;
set echo off;
spool 600.sql
select table_name from META82_DSG_SYNC where id <=600;
spool OFF;
exit;
EOF
sed -i '/SQL>/d;s/^/select first 1 * from &/g;/^*$/d;s/ *$//;s/$/&;/g' ./600.sql #格式化输出
# 拷贝到源端
scp 600.sql zte_jzf@135.129.24.82:/home/zte_jzf/dsg/ifm_hp_82_s1/